International address formatting requires reports in all modules to
use the FULL_ADDRESS, Name.FULL_ADDRESS, Name_Address.FULL_ADDRESS, Orders.FULL_ADDRESS, or Order_Badge.FULL_ADDRESS fields rather than a concatenation of the individual address fields.
These fields are calculated based upon the address format associated
with the Country name in the Name Address record. Whenever FULL_ADDRESS is calculated, it is built based upon the appropriate address format.
If international address formatting is set up, these FULL_ADDRESS fields are calculated based upon the address format associated with the Country name on the Name Address record. When a new record is inserted into the database, a new ASI stored procedure called sp_asi_AddressUpdate calculates all FULL_ADDRESS values based upon the country specific address formats.
To update the FULL_ADDRESS fields for existing records in the database, you will need to execute the 'Run AddressUpdate' script (select Utilities>Reports and Queries>Table Maintenance). This script calls the ASI AddressUpdate stored procedure that recalculates the FULL_ADDRESS fields based upon the appropriate address format.
If you have to run the 'Rebuild Name_Address Pointers' script for any reason, please note that you will also need to run the 'Run AddressUpdate' script in order to rebuild FULL_ADDRESS based upon the international address formats.
10.6 Production Release. Updated 1/18/2006 11:51:30 AM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.